select distinct *
FROM rcressource C
inner join postpla A
on C.matricule = A.matricule
inner join poste B
on A.codposte = B.codposte;

select * from postpla;
select C.matricule,libressource1,libressource2,libposte,mat.codcompet,comp.libcompet,comp.codcla,datdeb,datfin from rcressource C inner join gcmatcom mat on C.matricule = mat.matricule inner join gccompet comp on mat.codcompet = comp.codcompet inner join postpla pla on C.matricule = pla.matricule inner join poste po on pla.codposte = po.codposte where C.matricule = '02250';

select distinct(C.matricule),libressource1,libressource2,libposte,datdeb,datfin,mat.codcompet,comp.libcompet,comp.codcla 
from rcressource C 
inner join gcmatcom mat on C.matricule = mat.matricule 
inner join gccompet comp on mat.codcompet = comp.codcompet
inner join postpla pla on C.matricule = pla.matricule
inner join poste po on pla.codposte = po.codposte
